UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Uv8A9BZj7k/AoQVyvtVPKruNiA+JH0oziTOehLNfMMg='
WHERE
key_id = '6bd3f05ea3ec156a19b10b6fc6ee7bfe178fa266b18a1cabf12013e77b3ef6e0'
AND (
token = 'Uv8A9BZj7k/AoQVyvtVPKruNiA+JH0oziTOehLNfMMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)