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