UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7a9U3CZfENfUI8VAORBLpbuazoyB0cu6ZiahNs/ARDU='
WHERE
key_id = '0d06c5f93e0b360d7a3e0d5e1ab0bfc2fb220c3b1e858c4a7f7a7c18e480c6cd'
AND (
token = '7a9U3CZfENfUI8VAORBLpbuazoyB0cu6ZiahNs/ARDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)