UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XsROIKj34hHxIMUNpI1FrLJkSm3M5QptH2TOf/0AQXc='
WHERE
key_id = '000ebaecaa6814d5c8e11bb592fa1742e74f6901cd6ab34677a31349839159df'
AND (
token = 'XsROIKj34hHxIMUNpI1FrLJkSm3M5QptH2TOf/0AQXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)