UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KnAnpBf68PCg3fEHFWcpjESHfsbojir7eVdDoaRBrig='
WHERE
key_id = 'ea7e1dd59ff655b4b120e5dfa2d8842bb1c698ecdc3277636742aab3d4de2aa4'
AND (
token = 'KnAnpBf68PCg3fEHFWcpjESHfsbojir7eVdDoaRBrig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)