UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YADJq565KPPFbx1Yh3LI8S6zt6k+r93D7oWDxZRRArk='
WHERE
key_id = '78aea0d916911a9622075a7258166ad0e13c891d524aca63de5d31e4ba97f6e0'
AND (
token = 'YADJq565KPPFbx1Yh3LI8S6zt6k+r93D7oWDxZRRArk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)