UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5szym+U1CuWsbxBzLUpMXWTw/TZb9qoB6x66Dlk6C4I='
WHERE
key_id = '8a4850725ed9237914a5d7fb519816391c24b83a03918a1a1f6859fb8febcbd9'
AND (
token = '5szym+U1CuWsbxBzLUpMXWTw/TZb9qoB6x66Dlk6C4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)