UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iLWYdpGbWUMIN2vVroUvW/KZWc5SWktL02xLCZjgQyg='
WHERE
key_id = '8049c1e781bf42bad842698045e4df07ee1410640557169afceed8661082ff4c'
AND (
token = 'iLWYdpGbWUMIN2vVroUvW/KZWc5SWktL02xLCZjgQyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)