UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Csj4qD7cvXQt7w3GP6WO/mk3k+6nG+hL1D+CJk8rF4='
WHERE
key_id = '0a2ca9e01f8b8c741cdd7569117ed59638f141781e1d6f7cfa55abc62db9df94'
AND (
token = '2Csj4qD7cvXQt7w3GP6WO/mk3k+6nG+hL1D+CJk8rF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)