UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kJ8hDL3Hi8uvi8X2q61aKy+pPhSqvmrM+18gwEDSbE8='
WHERE
key_id = 'a9e5ed1aba04181fb1748d5e5710356017d152774342319ba98401732cf7c417'
AND (
token = 'kJ8hDL3Hi8uvi8X2q61aKy+pPhSqvmrM+18gwEDSbE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)