UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lNQkhLDI/XffKwA+3y1fb8FBVGDsti5uLJt0Se2jUn0='
WHERE
key_id = 'b46f21cc4769d737aa2d7a95aa22e7af11d7a5ce379baa8eee2655c353030494'
AND (
token = 'lNQkhLDI/XffKwA+3y1fb8FBVGDsti5uLJt0Se2jUn0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)