UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '636Bo0h2xoG/ikiZawWiqqQuUVkXDQv1R/zyDh1I+d8='
WHERE
key_id = '78c3c7c78f3c82e439ac3366174cab0c614f929333487a1342b4e7edf4e852f1'
AND (
token = '636Bo0h2xoG/ikiZawWiqqQuUVkXDQv1R/zyDh1I+d8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)