UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'csauiOIquCe46rq3YzixD6oNaXvRL31tEFncdi+8Mgg='
WHERE
key_id = 'b278f942c0492ed2a099ad4c5c33f4d9002682268ae97b453ac11999e75ef183'
AND (
token = 'csauiOIquCe46rq3YzixD6oNaXvRL31tEFncdi+8Mgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)