UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VYQxgi4Hxh2KghWDfZ3ZPCnt0HlNCHZd7sGq5G86+wo='
WHERE
key_id = '3cab888f6550f10b5e2dcb642865ff7acfba97714543e0be63d351a0b9c851ee'
AND (
token = 'VYQxgi4Hxh2KghWDfZ3ZPCnt0HlNCHZd7sGq5G86+wo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)