UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prwj4dqKoen4mNizHz757lS3ChaJ+q/BIPHQWkHklPw='
WHERE
key_id = '0cbf4c44b4390587d6e19738ea1a6e1f55e6d3868b32e7eda0a6eb63e67159f8'
AND (
token = 'prwj4dqKoen4mNizHz757lS3ChaJ+q/BIPHQWkHklPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)