UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UpgTlXf32g6gRTqmAPmmKSfCTUx8pKrjP4V0H7oxa+c='
WHERE
key_id = '78bdfcc09445fde8e751380d0b65df4237abb6567095593bcdff7689117ba1a1'
AND (
token = 'UpgTlXf32g6gRTqmAPmmKSfCTUx8pKrjP4V0H7oxa+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)