UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eR0be8dmI0J0hKzwVtIFaNn3dLOHD0ToP/+K1KcQpd8='
WHERE
key_id = '6da1d31673e2f896fb8d2c97af1d8e27efdb00b94d646c64033be3e964ed0b59'
AND (
token = 'eR0be8dmI0J0hKzwVtIFaNn3dLOHD0ToP/+K1KcQpd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)