UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hd0AFke8v0gGQIgs7vflY3xf32xi8CQz37/AK2VsnIo='
WHERE
key_id = 'e7e71905b9543085156875c8d0f10db0748a0f69f0421ac8948009dd7623fedf'
AND (
token = 'hd0AFke8v0gGQIgs7vflY3xf32xi8CQz37/AK2VsnIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)