UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoZ7fgb3C5dh3ZKUy7vAtHCktJ05BZ5dxRx8Ef4tUjw='
WHERE
key_id = 'd29bad2f066acde4738e5011186bfbe46a935628fe8cbc58fe8b448755d61bd5'
AND (
token = 'zoZ7fgb3C5dh3ZKUy7vAtHCktJ05BZ5dxRx8Ef4tUjw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)