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