UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pz9gr7IP7INQvD8+96XmD8Zl0BlkkbuGB02c9ZuLjd0='
WHERE
key_id = '5813686d39b11614e1805f78d7e1909dd8d38426f8a0bf9cd1c07b0ddfb8aea8'
AND (
token = 'pz9gr7IP7INQvD8+96XmD8Zl0BlkkbuGB02c9ZuLjd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)