UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpA+fHaLqgzgVKXGI/F9V5X7dTo3jc8QQ77hNsYjAkQ='
WHERE
key_id = 'af24f472f3a106478f6ab5ae48bbd584383f916711b831dd7db557b06389939c'
AND (
token = 'zpA+fHaLqgzgVKXGI/F9V5X7dTo3jc8QQ77hNsYjAkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)