UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vM8Hdbub5FuLN/aJywSYIQv+OnvG9Gipl8cEbbLAJvs='
WHERE
key_id = '12d5f8623980e4b97dbd8236b3523e4a83b6c50f778dd0cb1497ba5b3d5b6231'
AND (
token = 'vM8Hdbub5FuLN/aJywSYIQv+OnvG9Gipl8cEbbLAJvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)