UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IY4plfaO+2TGpMFuGzMpriLfZDxmHIqC2ENzhPka6MI='
WHERE
key_id = 'c8f66a0111a08aa4b30a70d32ffd6ef0ca3c8f9ce4c3124ea9f6b250174390aa'
AND (
token = 'IY4plfaO+2TGpMFuGzMpriLfZDxmHIqC2ENzhPka6MI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)