UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'plexGQh+0hrMSX0/gnuuzuBXQIEsvLmIV9m+ha15WvM='
WHERE
key_id = '502b8e3e24343fd64c9cb51e6ce28a8f14c83925a0eee6fd47be2ab20f122355'
AND (
token = 'plexGQh+0hrMSX0/gnuuzuBXQIEsvLmIV9m+ha15WvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)