UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBktU4KHBqUstrEF7v0YYLA/b2+02TJj68NYqeNTLXE='
WHERE
key_id = 'c2d6663f38b09023bd558b3ff4f942988491243416347968d9b1ddb108ad4249'
AND (
token = 'pBktU4KHBqUstrEF7v0YYLA/b2+02TJj68NYqeNTLXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)