UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6vJNobmHAcqOjHi56QsthrAOHoj+vGFz5KXzIz1H/o='
WHERE
key_id = '012b4a875b21fad0d495c1bf72462b9dc4a549741630a1ca3baa3556e4187678'
AND (
token = 'a6vJNobmHAcqOjHi56QsthrAOHoj+vGFz5KXzIz1H/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)